PM Payment WORK (PM10300)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Payment WORK (PM10300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM10300

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Payment WORK
Physical Name: PM10300
Technical Name: PM_Payment_WORK

Group Display Name: Payables Transaction Logical File
Group Technical Name: PM_Transaction_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BACHNUMB	Batch Number	String	STR15_LBAU	15
2	BCHSOURC	Batch Source	String	STR15	15
	Records whether the transaction was entered in a batch or not. Click to show/hide the Batch Sources PM_Trxent Batch XXPM_Trxent No batch (real-time)
3	PMNTNMBR	Payment Number	String	STR20_LBAU	20
4	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PM Payment WORK'].CHEKBKID AS 'PM Payment WORK-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PM Payment WORK'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
5	DOCDATE	Document Date	Date	DT	8
6	DOCNUMBR	Document Number	String	STR20_Document_Number	20
7	APPLDAMT	Applied Amount	Currency	DLR17_RBS0_STR$	17
8	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
9	CHEKTOTL	Check Total	Currency	DLR19_RBS0_UTR$	19
10	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['PM Payment WORK'].VENDORID AS 'PM Payment WORK-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['PM Payment WORK'].VENDORID = ['PM Vendor Master File'].VENDORID
11	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
12	COMMENT1	Comment1	String	STR30	30
13	ADDRESS1	Address 1	String	STR60	60
14	ADDRESS2	Address 2	String	STR60	60
15	ADDRESS3	Address 3	String	STR60	60
16	CITY	City	String	STR35	35
17	STATE	State	String	STR30_State	29
18	ZIPCODE	Zip Code	String	STR10	10
19	COUNTRY	Country	String	STR60	60
20	VNDCHKNM	Vendor Check Name	String	STR64_Vendor_Name	64
21	SOURCDOC	Source Document	String	STR10_Source_Document	10
	Key to the Source Document Master (SY00900). Click to show/hide SELECT ['PM Payment WORK'].SOURCDOC AS 'PM Payment WORK-Source Document' ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN SY00900 AS ['Source Document Master'] ON ['PM Payment WORK'].SOURCDOC = ['Source Document Master'].SOURCDOC
22	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
23	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
24	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
25	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PM Payment WORK'].CURNCYID AS 'PM Payment WORK-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PM Payment WORK'].CURNCYID = ['Currency Setup'].CURNCYID
26	VOIDED	Voided	Boolean	CB	0
27	REPRNTED	Reprinted	Integer	INT2	2
28	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
29	PGRAMSBJ	Percent Of Gross Amount Subject	Integer	INT5_RBS2_U%	5
30	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
31	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
32	LDOCRMTC	List Documents on Remittance	Integer	DDL_List_Documents_On_Remittance	0
33	SDORMBY	Sort Documents on Remittance By	Integer	GB	0
34	KEYFIELD	Key Field	String	STR20	20
35	AMWDSNBR	Amount in Words and Numbers	String	STR60	60
36	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PM Payment WORK'].NOTEINDX AS 'PM Payment WORK-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PM Payment WORK'].NOTEINDX = ['Record Notes Master'].NOTEINDX
37	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['PM Payment WORK'].VCHRNMBR AS 'PM Payment WORK-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['PM Payment WORK'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['PM Payment WORK'].DOCTYPE = ['PM Key Master File'].DOCTYPE
38	CNTRLTYP	Control Type	Integer	INT1	1
	The Control Type records the type of transaction. Click to show/hide Control Types 0 Voucher types 1 Payment types 2 Printed alignment forms
39	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
	Click to show/hide Document Types 1 Invoice 2 Finance Charge 3 Miscellaneous Charges 4 Return 5 Credit Memo
40	MODIFDT	Modified Date	Date	DT	8
41	MDFUSRID	Modified User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PM Payment WORK'].MDFUSRID AS 'PM Payment WORK-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PM Payment WORK'].MDFUSRID = ['Users Master'].USERID
42	PSTGSTUS	Posting Status	Integer	INT	0
43	POSTEDDT	Posted Date	Date	DATE	6
44	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PM Payment WORK'].PTDUSRID AS 'PM Payment WORK-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PM10300 AS ['PM Payment WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PM Payment WORK'].PTDUSRID = ['Users Master'].USERID
45	PMWRKMSG	PM WORK Messages	Long Integer	ML_PM_WORK_Messages	0
46	PMWRKMS2	PM WORK Messages 2	Long Integer	ML_PM_WORK_Messages_2	0
47	PMDSTMSG	PM Distribution Messages	Long Integer	ML_PM_Distribution_Messages	0
48	CHKCOMNT	Check Comment	String	STR60	60
49	PSTGDATE	Posting Date	Date	DT	8
50	STRGA255	String A 255	String	STR255	255
51	STRGB255	String B 255	String	STR255	255
52	SEPRMTNC	Seperate Remittance	Boolean	CB_Seperate_Remittance	0
53	STBOVRFL	Stub Overflow	Boolean	CB	0
54	CTYSTZIP	City-State-Zip Code	String	STR47	47
55	TotDocAmt	Total Document Amount	Currency	DLR19_RBS0_STR$	19
56	TotAmtPaid	Total Amount Paid	Currency	DLR19_RBS0_UTR$	19
57	TotCrdAmt	Total Credit Amount	Currency	DLR19_RBS0_UTR$	19
58	TotalPaidTot	Total Paid Total	Currency	DLR19_RBS0_UTR$	19
59	TotNegTot	Total Negative Total	Currency	DLR19_RBS0_UTR$	19
60	TotCrdDocAmt	Total Credit Document Amount	Currency	DLR19_RBS0_UTR$	19
61	TotTotDocAmt	Total Total Document Amount	Currency	DLR19_RBS0_UTR$	19
62	TotDiscTknAmt	Total Discount Taken Amount	Currency	DLR19_RBS0_UTR$	19
63	TotWOAmt	Total Write Off Amount	Currency	DLR19_RBS0_UTR$	19
64	TotPPSAmtDed	Total PPS Amount Deducted	Currency	DLR19_RBS0_UTR$	19
65	TotGSTDiscAmt	Total GST Discount Amount	Currency	DLR19_RBS0_UTR$	19
66	TotDiscTknTot	Total Discount Taken Total	Currency	DLR19_RBS0_UTR$	19
67	TotWOTot	Total Write Off Total	Currency	DLR19_RBS0_UTR$	19
68	Outstanding_Amount	Outstanding Amount	Currency	DLR19_RBS0_UTR$	19
69	Net_Paid_Amount	Net Paid Amount	Currency	DLR19_RBS0_UTR$	19
70	Electronic	Electronic	Boolean	CB_Electronic	0
71	PONUMBER	PO Number	String	STR17_POP_Number	17
72	CARDNAME	Card Name	String	STR15_Card_Name	15
73	PYENTTYP	Payment Entry Type	Integer	GB	0
	Click to show/hide Payment Entry Type 0 Check 1 Cash 2 Credit Card
74	LNGDESC	Long Description2	String	STR200	200
75	AMTINWDS	Amount in Words	Text	TX500	500

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Payment WORK (PM10300)

Leave a Reply Cancel reply